SUMMARY

• More than 10 Years of Telecom & IT Industry experience
• Microsoft Certified Professional in SQL Server
• Strong understanding of Microsoft SQL Server 2008R 2/2012/2014/2016 Internals
• Strong understanding of Database Performance Troubleshooting and enhancements
• Strong knowledge of SQL Server database administration and best practices
• Hands on Cloudera (Big data) and Hadoop cluster setup.
• Strong knowledge Amazon Web Services (AWS) Cloud architecture and Services
• General understanding of object oriented software architecture, design, and implementation
• Strong experience taking business requirements, creating functional specifications and designing solutions
• In depth knowledge of Telecom domain from both business and technical aspects
• Worked as Systems Analyst on medium to large - scale projects Experience in the telecommunications/mobile industry
• Experience in Interconnect/Wholesale Billing & Routing carrier Business.
• Strong analytical and problem-solving skills

TECHNICAL SKILLS

• Windows Server 2003/2008/2012/2016
• IBM AIX 1.5,1.6, Centos 6, RHEL 7
• PL/SQL, Unix Shell Scripting, T-SQL, HTML
• Putty, Toad, Oracle BI Tools (Discoverer and Administrator), Pentaho BI tools, Octopus UI Deploy tools
• Microsoft SQL Server Tools; AWS Web Services
• Cloudera Big data Hadoop Administration
• Oracle(9i,10g,11g), Postgre SQL
• Microsoft SQL Server 2005,2008,2014/2016
• Confidential -Interconnect Optimised Routing (IOR)
• Confidential -Intercnnect Billing System (ICT)
• Confidential - iXTools, iXLink
• Arptel- Test Call Generator from Arptel and Assure
• Least Cost Routing, Interconnect, Trading and Routing Business, Switch, Mediation, Wholesale Voice and SMS, Revenue Assurance, Fraud Detection

PROFESSIONAL EXPERIENCE

Confidential

Lead-Production Engineer

Responsibilities:

• Installation of the iXTools software ( Confidential ) on the client premises.
• Estimating hardware and software pre-requisites depending on the client traffic and other business parameters like traffic retentions period, no. of users, benchmarking etc.
• Data migration from production to staging servers, upgrading the iXTools software on client environments.
• Leading and helping the team with appropriate guidance and monitoring.
• Creating project plans, co-ordination/alignment with clients and internal team and executing the plans during the scheduled time.
• Assist in the physical and logical architecture and design of relational database schemas
• Participate in multiple high priority projects simultaneously while interacting with peers to make the best technical decisions
• Develop procedures and scripts for data migration
• Working on scripts in Unix Shell scripting & administering Linux server instances, creating/mounting/formatting volumes, users security, roles and permission
• Hands on experience on Big data-Cloudera Hadoop cluster setup and administration
• Working on Amazon Web Services (AWS) and creating/managing EC2 instances, subnets, Security groups, Load balancers (ELB), Creating AMI’s (Amazon Machine Images) on AWS console, AWS RDS and AWS IAM
• Installing Pentaho BI suite softwares and Designing dashboards/reports in Pentaho BI tool and installing and managing Pentaho 6.0 BA suite using Docker Images and Containers
• Writing scripts/stored procedures in SQL server to automate the day to day activities like backups/restore, providing fix for the bugs to developers.
• DBA related activity like Monitoring SQL Server Agent, debugging scripts, Database Backups/restore,, performance tuning of the queries, monitoring SQL instances, optimizing memory and cpu usage, maintaining databases/sql server level security, creating databases alerts and emails etc.
• Work on CDR traffic Load Balancing, Upgrading iXTools softwares, deploying iXTools patches on the Client’s staging and production environment.

Confidential

Sr. Development Consultant

Responsibilities:

• Receive business requirements and translate them into functional and system requirements.
• Designing Data Model for various telecom operators and creating data loader templates as per the product design
• Implemented and performing UAT of the configuration in Interconnect as per the specific requirement of operator like Confidential Madagascar (onsite), Confidential Congo (onsite), Confidential Kenya etc.
• Contribution in delivery of the product solutions by involving in RA (Revenue Assurance) validation and analyzing and modifications as per their requirement.
• Business Meeting with vendors, clients, preparing system requirement documents, giving product/business training to the business, making implementation plans
• Deploying the solution in Production and validating the system after go-live
• Consistently strive for high quality database solutions and exhibit a strong sense of ownership
• Consistently look for opportunities to automate manual processes.
• Develop and optimize stored procedures and functions using Oracle PL/SQL
• Review and modify new and existing stored procedures to enhance performance and in corporate best practices while encouraging and educating others

Confidential

Responsibilities:

• Interacting with Architects, Business Analysts, Developers, Test, Operations, and Management in order to effectively support both purchased and internal applications.
• Initiate business requirements gathering, creating functional specifications in order to meet the business needs, and aid in application design.
• Delivery and installing the software/patches at customer environment
• Co-ordination with the system integrator and the production support team to ensure product delivery on time and achieving billing milestones.
• Working and Oracle PL/SQL and creating new reports for business in Oracle BI tools (Oracle Discoverer and Administrator).
• Fulfill various client service requests.